Periodically, the interim tables used by iMIS reports and queries should be cleared of old data. You can accomplish this by running the sp_asi_ClearOldQueryResults script.
To clear old data from the query results tables
A message window opens and asks you to confirm that you want to run the script, and the Run ClearOldQueryResults script window opens.
The script is run and the number of rows fitting the deletion criteria is reported in Run ClearOldQueryResults script window.
The Run ClearOldQueryResults script window closes.
10.6 Production Release. Updated 2/20/2006 12:31:34 PM
© 2009 by Advanced Solutions International, Inc.
All rights reserved.